New on v 6.3.0.0


Rad Studio XE6 Support.
Now FlexCel supports Rad Studio XE6.

SVG Exporting.
A new component, FlexCelSVGExport allows to export xls/x files to SVG. A new example "Export SVG" is included too. SVG files are now supported by all major browsers, desktop and mobile, so you can use them when exporting to html to have resolution independent images.

HTML 5 Exporting.
Now FlexCelHtmlExport can export to HTML5/CSS3 as one of the options. When exporting to HTML5 some new capabilities are available.

Improved support for document properties.
Full support for setting standard or custom properties in xlsx files. (xls is still read only). A new method XlsFile.DocumentProperties.RemoveAllProperties will allow you to remove all properties in the xls or xlsx files, so you can be sure it doesn't contain unwanted information. A new method XlsFile.DocumentProperties.GetUsedStandardProperties will return a list of the used standard properties in the file. A new method XlsFile.DocumentProperties.SetUsedStandardProperty allows to modify standard properties in xlsx. New methods SetCustomProperty, GetCustomProperty and GetAllCustomProperties allow to manage custom properties.
Document properties will be preserved when opening xls or xlsx files and saving as xlsx, or when opening and saving as xls. They won't be preserved when opening xlsx and saving as xls.

Embed images in HTML files.
A new property: FlexCelHtmlExport.EmbedImages allows to embed the images as Data Uris ( http://tools.ietf.org/html/rfc2397 ) inside the html file. When setting this property to true the generated html file can be self contained, and you don't have to deal with managing the external images.

SVG images in HTML files.
Now FlexCelHtmlExport.SavedImagesFormat allows a new possibility: THtmlImageFormat.Svg. SVG is a standard vector image format supported by most modern browsers, and using svg means that high-dpi/retina devices can zoom smoothly in the vector assets of the file, like charts or autoshapes.

TExcelChart.RemoveLegend method.
A new method in TExcelChart allows to remove a legend. Note that currently this only works in xls charts, not xlsx.

Improved chart rendering.
Now charts will have the frame box with rounded corners if you specify so in Excel.

Improved performance in VLookup.
The implementation of the function VLookup is now much faster when searching in an unsorted range.

Improved performance in pdf/html exporting.
Many optimizations in the rendering engine.

Improved APIMate.
APIMate now shows how to autofit a comment box to the text size, and also how to set properties in xlsx.

Bug fix.
Some cells with automatic background colors in xls files could be saved with the wrong color when converting to xlsx.

Bug fix.
XlsFile.Find could keep returning the same values in corner cases.

Bug fix.
When Inserting an empty sheet locally defined ranges wouldn't update the sheet where they were defined. This happened only with empty sheets, if you inserted a sheet with data it would work fine.

Bug fix.
FlexCelPreview could show text as underlined in some third party generated xlsx files.



New on v 6.2.0.0


Support for preserving PowerPivot tables in xlsx.
Now PowerPivot tables will be preserved in xlsx.

New methods FlexCelDllInit and FlexCelDllShutdown.
These new methods are designed to be called when you encapsulate FlexCel inside a dll. You need to call them from inside your main application before calling any methods in the dll. They will initialize and shutdown GDI+, as that needs can't be done from the dll itself.

Improved Excel 2013 support.
FlexCel could fail to open some complex Excel 2013 xlsx files.

Improved handling of dates between 1900-1-1 and 1900-2-28.
Excel considers 1900 to be a leap year, even when it wasn't. ( look at http://support.microsoft.com/kb/214326 ) As FlexCel uses the .NET DateTime which correctly assumes 1900 wasn't a leap year, dates between 1900-1-1 and 1900-2-28 would appear in FlexCel as one day before the dates in Excel. Now FlexCel corrects those dates so they look as in Excel, but the DateTime datatype still doesn't have Feb-29-1900, so that date will still be wrong. It is still advised to not use dates before march-1-1900 when working in Excel.

Support for running in machines with FIPS 140 enabled.
Now FlexCel can be used in machines with FIPS 140 policies enforced. ( see http://support.microsoft.com/kb/811833 )

Improved rendering of formatted numbers.
Some formatting strings (for example "general;-general") were not rendered like Excel.

Improved default font in Headers and footers.
In previous versions if no font was specified for the headers or footers, FlexCel would default to Arial. Now it defaults to the normal font in the file.

Support for displaying numbers in Engineering notation.
When displaying numbers in Scientific notation, FlexCel would always use normalized notation ( http://en.wikipedia.org/wiki/Scientific_notation#Normalized_notation ). Now it can also use Engineering notation if the format string specifies it ( http://en.wikipedia.org/wiki/Engineering_notation )

iOS and Android pdf encoding handling.
Now FlexCel will create pdf files without using Win1252 encoding, which isn't included by default in Xamarin for iOS or Android.

SheetProtection is copied when copying sheets from one file to another.
Now FlexCel will copy the sheet protection when you are copying sheets from other file object.

Bug fix.
The rendering engine could fail to draw the top gridline in pages after the first when PrintGridLines was true and you were repeating rows at the top.

Bug fix.
When opening xls files with data validations and saving them as xlsx, some relative ranges could point to an incorrect cell range in the xlsx file.

Bug fix.
Charts in xlsx files didn't preserve textures.

Bug fix.
There was an error when recalculating the =LARGE and =SMALL functions in non contiguous ranges of cells.

Bug fix.
GDI+ could fail to work in Windows Server 2008 R1, due to a bug in the VCL.

Bug fix.
Sometimes AddFormat() could repeat a format twice in the file.

Bug fix.
In certain cases when a macro name had a dot "." on it, FlexCel could fail to open the file.

Improved 3rd party compatibility.
Improved generated xls files so they can be loaded by some 3rd party tools.



New on v 6.1.1.0


Ability to change the sheet codename.
When the file has no macros, now FlexCel will allow you to change the codename, not only read it. Also now when calling ClearSheet, the codename is not changed.

Improved C++ builder support.
Fixed pragma links for handling all combinations: 64/32 bits, OSX/Windows, with runtime packages or without. If you were using pragma links to FlexCel in your code before, you should be able to remove them all now.

Bug fix setting Autofilters.
A very specific combination of setting and unsetting autofilters could raise an AV.



New on v 6.1.0.0


Rad Studio XE5 and Android support.
FlexCel can now run in Android with XE5. In includes a native Android canvas (not FireMonkey) for maximum performance, same as the other native canvas for iOS, Windows and OSX.

Improved chart rendering.
While the chart engine still can only draw charts in xls files at the moment, it can now read some embedded xlsx records in the xls file so the chart will display like Excel 2007 or newer, not like Excel 2003.

Improved xlsx autoshape rendering and conversion.
Now autoshapes in xlsx files are converted better to xls, and also render more faithfully.

Improved rendering in iOS and Android.
Now texture bitmaps are also supported in iOS and Android besides Windows.

iOS7 support.
Changes to better support iOS7.Some records in xlsx files have been changed so the iOS7 viewer can show the files.

New static events in TPdfWriter.
There are 3 new static events: GetFontDataGlobal, GetFontFolderGlobal, OnFontEmbedGlobal. Those work like the already existing GetFontData, GetFontFolder and OnFontEmbed, but being static, they work an application level. If you set them, you don't need to set them for every TPdfWriter or TFlexCelPdfExport instance you create.

Support for forcing codepage in Excel95.
Now you can force a codepage when opening an Excel 95 file with xls.Open(..., Encoding). While normally you don't need to specify a codepage for xls95 since it is specified in the file, if the file doesn't have a codepage record or has it wrong, you can now specify it here.

Bug fixes.
Small bugfixes.



New on v 6.0.6.0


Ability to autofit part of a column or a row.
Now you can autofit a column using for example the data in the first 50 rows, making it faster for huge spreadsheets.

Many small fixes and improvements.
Performance tweaks, bug fixes, small improvements.



New on v 6.0.1.0


New TFlexCelFormatSettings allows better control of the locale FlexCel uses for converting numbers to strings.
There is a new TFlexCelFormatSettings class which allows you to change the numeric and date strings like the decimal separator for FlexCel only, no matter what the rest of your application is using. You can change it both for globally for your full application, or for the current thread only. Look at the API guide for more information.

New startPageToExport and totalPagesToExport parameters in TFlexCelPdfExport.ExportSheet.
Those methods allow to control how many pages are exported.

HotFix for QC 116108.
This is a hotfix for bug http://qc.embarcadero.com/wc/qcmain.aspx?d=116108 in the OSX/iOS RTL. Without this bug fixed, FlexCel could confuse the named ranges and print the wrong page range. With this hotfix it will behave correctly even without the QC fixed.

Fix for Corrupt FireMonkey in Windows preview.
Under some graphics cards, the FlexCelPreview component in FireMonkey for windows could display wrong. This should be fixed now.



New on v 6.0.0.0


XE4 and iOS Support.
Read, write, modify, preview, print and export to pdf your Excel files from any iOS device. New components to export and import files from and to your application. New demos and tutorials on how to create iOS applications using FlexCel.

Reduced Memory usage.
FlexCel 6 will use from about 1/2 to 1/4 of the memory FlexCel 5 used. We've done a big rearchitecture of the code to ensure it runs fine in memory-limited devices, and this improvement is also available for Windows.

More conformant xls files.
All xls files created by FlexCel now pass the Microsoft Office validator if the original file passed it. Note that not all xls files created by Excel pass the Office validator.

In OSX and iOS the pdf engine doesn't need more access to the "Fonts" folder.
Now the pdf engine in OSX and iOS an get the fonts directly from memory.

Many small improvements.
In this release we've taken a lot of time reviewing the small details, making the engine a little faster and a little better all around.



New on v 5.6.10.0


New startPageToPrint and totalPagesToPrint parameters in TFlexCelPrintDocument.PrintSheet.
Those methods allow to control how many pages are printed.



New on v 5.6.9.0


New BackgroundColor property in FlexCelHtmlExport.
This allows you to define the background color for empty cells when exporting to html. You can also set it to transparent if you are customizing the html to have a custom background image or texture, so the cells show through it.

New Parameter to rename the files created by FlexCelHtmlExport.ExportAllVisibleSheetsAsTabs.
Now ExportAllVisibleSheetsAsTabs has a parameter named "OnSheetName" where you can pass an anonymous method and use it to specify how the filenames for every html file for every tab are created based in the corresponding sheet name.

New Macros admitted in the SheetSeparator when exporting all sheets as a single file.
You can now also write <#prevSheetName> and <#prevSheetPos> in the sheet separator, and they will be replaced by the previous sheet name and position respectively.



New on v 5.6.8.0


New DefaultRowHidden property in TExcelFile.
This new property allows you to hide all empty rows in the file.

Performance improvements.
VLookup, HLookup, Lookup and SumProduct are faster in recalculations.



New on v 5.6.7.0


New AutofitComment method in TExcelFile.
This new method allows you to resize a comment box so all text fits inside.



New on v 5.6.5.0


XE3 Update 1 support.
This release adds compatibility with the new 64 bit C++ builder compiler.

Reduced exe size.
There has been a reduction in the sizes of applications which use FlexCel.

Support for recalculating XIRR and XNPV functions.
XIRR and XNPV are now recalculated.

Performance enhancements.
Small performance enhancements in different places.



New on v 5.6.0.0


Preview support in firemonkey.
Introducing a new native preview component for firemonkey. Fully styleable, and uses native coregraphics or GDI+ depending on the platform for better performance. See the new "Custom preview" demo in firemonkey. Note: Printing in firemonkey is not yet available.

Bug fixes.
Many small bug and stability fixes.



New on v 5.5.0.0


INTELLIGENT PAGE BREAKS.
Even when there is no direct support for widow/orphan lines in Excel, FlexCel now provides a way to keep rows and columns together avoiding page breaks in the middle of important data.
You tell FlexCel which rows you want to keep together, and it will automatically add page breaks at the needed points in the file so it prints as you want to. This new feature can be used both from the API or from the reports. For more information, look at the "Intelligent Page Breaks" demos in the Report and API sections.

Rad studio XE3 Support.
Rad studio and Firemonkey 2 are supported.

Native exporting of xls/x files to pdf.
Now FlexCel can export any xls/x file to pdf. Export is native, not third party dlls, Excel or Acrobat are needed. Charts are exported in xls, not yet in xlsx.

Native exporting of xls/x files to html.
Now FlexCel can export any xls/x file to fully standards compliant html. Also it can create MHTML files, that can be used for sending html email.

Native previewing of xls/x files.
Now FlexCel can preview any xls/x file as it would be printed. Previewing is not yet available in FireMonkey.

Native printing of xls/x files.
Now FlexCel can natively print any xls/x file. Printing is not yet available in FireMonkey.

Support for reading and writing encrypted xls and xlsx files.
Support for Excel 95, 2003, 2007, 2010 and 2013 encryption modes. Encryption is available only in Windows, 32 or 64 bits, Firemonkey or VCL. Not yet in OSX.

AUTOFITTING SUPPORT.
Now you can autofit rows or columns with XlsFile.AutoFitRow, XlsFile.AutoFitCol and XlsFile.AutoFitWorkbook methods. On reports, the new tags <#Row Height> and <#Column Width> allow to change the row height / column width in a report, and to hide, show or autofit columns and rows. See the new Autofitting demo on the reports section.



New on v 5.1.2.0


Small bug fixes.
Stability fixes.



New on v 5.1.0.0


Many important bug fixes and improvements.
For FlexCel 5.1 we focused in polishing every bit of the code, porting thousands of tests and making sure every one was passing, optimizing the code and making it faster, and we even managed to make the executables 700 kb smaller. 5.1 is a very important release and very recommended update from 5.0.5

APIMate.
ApiMate for Delphi/C++ Builder is a tool that can open any existing xls/x file, and show you the Delphi or C++ code needed to create that file with FlexCel. It is a very helpful tool for learning the FlexCel API.

Improved virtual mode.
Virtual mode now can skip sheets you don't need to read, and also stop reading the file as soon as you have read all the values you need. Look at the improved "Virtual Mode" demo for more information.

New demos.
Many new API demos.



New on v 5.0.5.0


Recalculation.
Now FlexCel can natively recalculate the files, with support of over 200 functions.

Bug fixes.
Many bug fixes and added support for TXlsxAdapter component for using FlexCel 5 from FlexCel 3. TXlsxAdapter allows you to use a v3 FlexCelGrid with recalculation and xlsx support.



New on v 5.0.2.0


C++ Builder XE2 support.
Now you can use FlexCel from C++ Builder XE2.

Integrated help.
Now we include integrated reference for all classes and methods, that you can access by pressing F1 inside RAD Studio.

Bug fixes.
Small bug fixes and added support for TAdvGridExcelExport and TAdvGridExcelImport.



New on v 5.0.0.0


First release with the new code base.
FlexCel 5 has been completely rewritten based in the code for FlexCel .NET. There are too many changes to mention, but among them we have Xlsx file support, new reporting engine, pdf export, html export, FireMonkey support, etc.